<?php
/***************************************************************
*  Copyright notice
*
*  (c) 2008 Starbugs <univis2typo3@googlegroups.com>
*  All rights reserved
*
*  This script is part of the TYPO3 project. The TYPO3 project is
*  free software; you can redistribute it and/or modify
*  it under the terms of the GNU General Public License as published by
*  the Free Software Foundation; either version 2 of the License, or
*  (at your option) any later version.
*
*  The GNU General Public License can be found at
*  http://www.gnu.org/copyleft/gpl.html.
*
*  This script is distributed in the hope that it will be useful,
*  but WITHOUT ANY WARRANTY; without even the implied warranty of
*  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
*  GNU General Public License for more details.
*
*  This copyright notice MUST APPEAR in all copies of the script!
***************************************************************/

require_once(PATH_tslib.'class.tslib_pibase.php');


/**
 * Plugin 'publications' for the 'univis2typo3' extension.
 *
 * @author	Starbugs <univis2typo3@googlegroups.com>
 * @package	TYPO3
 * @subpackage	tx_univis2typo3
 */
class tx_univis2typo3_research_groups extends tslib_pibase {
	var $prefixId      = 'tx_univis2typo3_research_groups';		// Same as class name
	var $scriptRelPath = 'common/class.tx_univis2typo3_research_groups.php';	// Path to this script relative to the extension dir.
	var $extKey        = 'univis2typo3';	// The extension key.
	//var $pi_checkCHash = true;
	//var $cObj = "";

	function findAllGroups()
	{
		$select  = '`tpjo`.*, `trg`.*';
		$from    = "`tx_u2t3_person_job_order` AS `tpjo`
			    LEFT JOIN `tx_u2t3_research_groups` AS `trg` ON `trg`.`uid` = `tpjo`.`uid`";
		$where   = '`tpjo`.`is_group` = 1';
		$groupby = '';
		$orderby = '`tpjo`.`sorting`';
		$limit   = '';

		$query = $GLOBALS['TYPO3_DB']->SELECTquery(
			$select,
			$from,
			$where,
			$groupby,
			$orderby,
			$limit
		);

		//print $query; die();

		return $GLOBALS['TYPO3_DB']->sql(TYPO3_db, $query);

	}
}
?>
